set hive.exec.dynamic.partition=true;            --  动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=90;         --  每天生成 60 个分区
set hive.exec.max.dynamic.partitions.pernode=90; --  每天生成 60 个分区

insert overwrite table jms_dim.dim_lmdm_sys_tail_code_staff
select
id
,tail_code
,tail_id
,staff_id
,staff_code
,staff_name
from jms_ods.yl_lmdm_sys_tail_code_staff where dt= '{{ execution_date | cst_ds }}'
 distribute by 1 ;